﻿CREATE TABLE [dbo].[forum_moderator] (
    [forum_id] BIGINT NOT NULL,
    [user_id]  BIGINT NOT NULL,
    CONSTRAINT [PK_forum_moderator] PRIMARY KEY CLUSTERED ([forum_id] ASC, [user_id] ASC),
    CONSTRAINT [FK_forum_moderator_forum] FOREIGN KEY ([forum_id]) REFERENCES [dbo].[forum] ([forum_id]),
    CONSTRAINT [FK_forum_moderator_users] FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
);

